'use strict'

const pg = require('pg');
let psql = new pg.Pool({
    database: 'hmh',
    user: 'hmh',
    port: 5432,
    host: '127.0.0.1',
    password: '116H5dajun',
    //最大使用5个客户端连接
    max: 5
})

    ; (async () => {
        let tm = Date.now();
        //随机数字转化成16进制并去掉前两位
        let id = `${Math.random().toString(16).substring(2)}`

        let sqltext = `INSERT INTO `
            + ` content(id,detail,title,add_time,update_time)`
            + ` VALUES ($1,$2,$3,$4,$5)`

        let r = await psql.query(sqltext, [
            id, `测试内容:${Math.random()}`, `test`,
            tm, tm
        ])

        console.log(r)

        //关闭连接
        psql.end();
    })();